|
|
Comparison of reporting applications for mobile devices
Stejskal, Karel ; Šedivá, Zuzana (advisor) ; Novotný, Ota (referee)
This bachelor thesis focuses on the mobile devices market and the possibilities of their use for presentation of key business data using reporting applications. The goal of the thesis is to provide a comprehensive view of the mobile devices market as well as available reporting applications of commercial suppliers who play a crucial role in this segment. Then compare these applications using a multi-criteria evaluation based on a list of criteria and determine the most suitable application that has received the highest rating in this comparison. The final output is a table of compared applications with the ratings assigned to the individual criteria. The thesis serves as a basic orientation in the mobile reporting applications market. Application comparison results can be a useful source of information for companies planning to integrate them into their enterprise information system.
|
|
|
Design of a methodology for BI solutions in QlikView environment
Judová, Eva ; Pour, Jan (advisor) ; Kunst, Jan (referee)
This master thesis is devoted to a design for methodology of BI projects in QlikView. The main aim is to propose a recommended procedure solutions reflecting the strengths and weaknesses in the development of QlikView applications. Accompanying chapter to the discussed issue is a chapter Business Intelligence which explains the principles, characteristics and reasons for implementation in companies. Part of defining the differences between traditional and self-service solutions serves as a theoretical basis for understanding the increasing attractiveness of self-service solutions and environment of the proposed methodology. The next chapter presents the company Qlik as a market leader in BI and the owner of QlikView. The reasons for its establishment, subsequent development and actual vision are listed to create a comprehensive view of the environment where the described product was created. Along with the chapter focusing on characteristics and main advantages of QlikView a knowledge base is established for the implementation of proposed methodology. Crucial chapter of this thesis is based on the author's experience gained while implementing QlikView projects. The proposed methodology is based on the description of each phase, its activities, inputs and outputs and its concrete application in a demo environment for the area of receivables in manufacturing company. The key contribution of the author is pointing out potential problems during development or warning about critical parts or providing appropriate recommendations and benefits of the proposed procedures. The designed methodology can serve as a useful guide for self-service projects implemented the QlikView environment.
|
|
|
Comparison of selected commercial reporting BI platforms
Krečmerová, Petra ; Novotný, Ota (advisor) ; Daněk, Lukáš (referee)
This Diploma thesis focuses on a comparison of selected commercial reporting BI platforms. The goals of the thesis are to create pilot dashboards based on three Business Intelligence tools, compare these tools among themselves and select the most optimal one for creating dashboards. The theoretical part describes the problematics of Business Intelligence, its principles and components. These are divided into several layers such as production systems, transformation and data layers, data analysis and presentation layer. The performance dashboard are then described and an indepth analysis of the commercial tools market has been performed. In the practical part pilot dashboards are created based on retail chains data in three selected Business Intelligence tools Power BI, QlikView and Tableau. These are then compared and based on a multi-criteria analysis the optimal tool for creating dashboards is selected and recommended. The evaluation criteria, their weights using Fuller´s method and the final evaluation based on the Weighted Sum Approach are set in the analysis. The Diploma thesis is set up for a project of the Competency center Retail Analytics and for the professional community. It shall be used as one of the sources in the selection of BI reporting platform.
|
|
|
Design and implementation of margin reporting in travel agency
Švondrová, Aneta ; Kučera, Jan (advisor) ; Chlapek, Dušan (referee)
This thesis describes the design and implementation of the margins reporting in the travel agency. The main goal of the thesis is the design and implementation of a tool for margins monitoring of future package tours. The theoretical part provides an overview of resources devoted to Business Intelligence. The resources include various data sources which are specialized publications, scientific articles, theses and other electronic resources. Further, there are explained basic concepts related to Business Intelligence, benefits, principles and major components of Business Intelligence solution. At the end of the theoretical part is provided an overview of current Business Intelligence market trends and is introduced QlikView tool, which is used for creating reports in the practical part. The practical part is an analysis of the current situation of margins reporting in the travel agency. Problems are identified in this field. The company set requirements for implementation solution based on identified issues. Using knowledge gained in the theoretical part is designed a solution that meets the business requirements and this solution is implemented. The conclusion contains the verification of the solution implemented in practice and the evaluation of the fulfillment of the thesis objectives. The implementation of the margin reporting in the real company is considered as the main benefit of the thesis. The other benefit of the thesis is the description of the real case in which was used a tool based on in-memory analysis - one of the trends in Business Intelligence. Then there is the description of the case using Business Intelligence for a decision-making in one industry, travel agency.
|
|
|
Metadata driven financial reporting of a company
Kunst, Jan ; Pour, Jan (advisor) ; Kučera, Petr (referee)
Diploma thesis deals with analysis of common requirements of mid-sized and major companies for financial reporting and with design and development of reporting tool which meets such requirements. The target of the thesis is to create the tool for financial reporting, which would be universal and allows user to set up by himself, easily and without interfering the source code, those parts of reporting tool which usually varies for different companies, so they can't be set both universally and precisely in advance. The tool is developed in QlikView environment, which provides many advantages for quality reporting. My contribution within this thesis is in the use of nontrivial practices and maximal utilization of QlikView environment possibilities in order to make the final financial reporting tool modular, parameterizable, expandable and applicable in any company environment and to enable it to transfer the role of reports set-up towards the user.
|
|
|
Self Service BI - Present-day Architectural Problems
Formánek, Václav ; Pour, Jan (advisor) ; Pintér, Tomáš (referee)
The aim of the thesis is to define the term Self-service Business Intelligence. It is followed by an introduction of need of this technology in present information society. Thesis at last defines technologies and practices, which are applicable in most general situations. All defined recommendations are based on vast range of theoretical data sources. Second aim is to prove that all customers' requirements can be in specified case covered by functionality of Self-service BI solution. This proof is presented by an introduction of architectural proposal using chosen technological platform. This proposal is furthermore part of bigger elaboration, which by its content loosely follows all tasks present in the initial Case study.
|
|
|
KPI Implementation throught the BSC method in IT Company
Vongrej, Maroš ; Pour, Jan (advisor) ; Bauer, Miroslav (referee)
Diploma thesis deals with the implementation of Key Performance Indicators (KPIs) throught the Balanced Scorecard method in IT company. The thesis is divided into theoretical and practical part. The theoretical part focuses on the definition of terms related to the Performance Measurement and the Performance Management. The fourth chapter presents the Balanced Scorecard and its perspectives. The next section deals with the types of indicators and furhter focuses on the KPIs description. The practical part applies the theoretical knowledge gained in previous chapters into practice. The sixth chapter focuses on the analysis of the current position of the company and defines its strategic objectives, KPIs and strategic map. The seventh chapter focueses on the implementation of the solution in graphical form as application in QlikView.
|
|
|
Possibilities of In-memory reporting tools
Cígler, Lukáš ; Pour, Jan (advisor) ; Falta, Martin (referee)
Diploma thesis focuses on in-memory data processing, its use in reporting and Business Intelligence (BI) in general. The main goal of the theoretical part is to introduce the in memory principles, highlight the differences from hard drive data processing and overview possible implementations of in-memory technology in BI solution. The output of this section is an analysis of advantages and disadvantages of in-memory solutions in various perspectives. The practical part of the thesis consists of the performance benchmark that compares the performance of data processing using the in-memory principles and conventional hard drive methods. The performance comparison is realized in the reporting tools environment, QlikView for in-memory approach and Reporting Services for hard drive based method. Several data sets are used for testing in both mentioned tools. End of the chapter provides the assessment of testing results and discusses the strengths and weaknesses of both principles of data processing. The conclusion of this work discusses the advantages and disadvantages of in-memory data processing and defines the key questions that company management should ask before investing in innovation of the present BI solution. Moreover the conclusion contains recommendations for possible further follow-up work.
|
|
|
Implementation of KPIs in a selected manufacturing company
Vinc, Michal ; Pour, Jan (advisor) ; Kušnír, Róbert (referee)
This diploma thesis deals with implementation of key performance indicators by means of Balanced Scorecard in a selected manufacturing company. The aim of the thesis is to design a strategic map and propose key performance indicators based on Balanced Scorecard system which will lead to improved management of the company. Afterwards the outputs of the designed Balanced Scorecard are used for implementation of an initial Business Intelligence solution using currently available data of the company. The thesis is divided into theoretical part, which is introduced by research of available literature. Next the author describes approaches to business performance measurement, Balanced Scorecard itself and key performance indicators. In the practical part, the author performs a strategic analysis of the company and designs the Balanced Scorecard with key performance indicators for the company. In the second part of the practical part, implementation of the initial Business Intelligence solution in Qlikview application is described.
|
|
|
IT SOLUTIONS FOR EFFECTIVE HEALTHCARE MANAGEMENT
Šebej, Matej ; Štěrbová, Ludmila (advisor) ; Antonovič, Vladan (referee)
Why do the healthcare facilities incur debt? What troubles the managers most? In what conditions do the healthcare professionals work? Is there space for improvement? Is it possible to deliver higher quality care? Nowadays, the healthcare providers are looking for solutions, which could help them satisfy more patients, reach lower costs and therefore increase own financial results and answer the abovementioned questions. Key element of such a solution is a business intelligence system, which supports decision-making and aligns enterprise objects with its progress and improves the overall performance. The thesis elaborates on the topic of business intelligence software QlikView in selected hospitals, which already implemented or are about to implement the business intelligence software. The intention was to find out ways in which the software is used in the hospitals, what key performance indicators the software usually measures and what could be the possible opportunities for its further use in the selected facilities. Research results indicate that the software significantly increased the work efficiency and that it contributes to more effective hospital management. However, such improvement in efficiency has also its drawbacks, namely it is the higher price per personal licence in comparison to the other business intelligence software on the market. Research also confirmed the fact that only usage of such software alone will not help to improve the overall bad state of Slovak healthcare system -- systematic measures such as DRG system have to be implemented in the first place in order to also effectively use the business intelligence software.
|
guest ::
